import csv
from matplotlib import pyplot as plt
from datetime import datetime
import matplotlib.dates as mdate
import pandas as pd

filename = '安居客二手房.xls'
with open(filename) as f:
    reader = csv.reader(f)
    header_row = next(reader)

    highs = []
    for row in reader:

            high = (row[3])



            highs.append(high)


    print(highs)


# fig = plt.figure(dpi=128,figsize=(10,6))
# ax = fig.add_subplot(1,1,1)
# plt.plot(dates,highs,c='orange')
# # plt.plot(dates,winds,c='blue')
#
# plt.title('Daily high PM2.5')
# plt.xlabel('',fontsize=16)
# ax.xaxis.set_major_formatter(mdate.DateFormatter('%Y %b %d %H '))
# plt.xticks(rotation=30) # freq='MS',设置刻度格式为每月的开始（month start frequency）
# plt.ylabel('PM2.5',fontsize=16)
# plt.tick_params(axis='both',which='major',labelsize=16)
#
#
# plt.show()